The EDB Postgres Advanced Server must generate audit records showing starting and ending time for user access to the database(s).

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-69067	PPS9-00-012200	SV-83671r1_rule		Medium

Description
For completeness of forensic analysis, it is necessary to know how long a user's (or other principal's) connection to the DBMS lasts. This can be achieved by recording disconnections, in addition to logons/connections, in the audit logs. Disconnection may be initiated by the user or forced by the system (as in a timeout) or result from a system or network failure. To the greatest extent possible, all disconnections must be logged.

Description

For completeness of forensic analysis, it is necessary to know how long a user's (or other principal's) connection to the DBMS lasts. This can be achieved by recording disconnections, in addition to logons/connections, in the audit logs. Disconnection may be initiated by the user or forced by the system (as in a timeout) or result from a system or network failure. To the greatest extent possible, all disconnections must be logged.

STIG	Date
EDB Postgres Advanced Server Security Technical Implementation Guide	2016-08-19

Details

Check Text ( C-69541r1_chk )
Execute the following SQL as enterprisedb: SHOW edb_audit_connect; SHOW edb_audit_disconnect; If the result is not "all" for both, this is a finding.

Fix Text (F-75253r1_fix)
Execute the following SQL as enterprisedb: ALTER SYSTEM SET edb_audit_connect = 'all'; ALTER SYSTEM SET edb_audit_disconnect = 'all'; SELECT pg_reload_conf();